SET FOREIGN_KEY_CHECKS=0; Now you can fire your query. DELETE FROM TABLE WHERE ID = 'Somthing'; You can enable foreign key again SET FOREIGN_KEY_CHECKS=1;